object Form1: TForm1
  Left = 334
  Top = 120
  BorderStyle = bsDialog
  Caption = 'ZKECO3.2'#25968#25454#24211#21319#32423#24037#20855
  ClientHeight = 341
  ClientWidth = 564
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object GroupBox1: TGroupBox
    Left = 0
    Top = 0
    Width = 257
    Height = 324
    Align = alLeft
    Caption = #25968#25454#24211#37197#32622
    TabOrder = 0
    object Label1: TLabel
      Left = 8
      Top = 32
      Width = 72
      Height = 13
      Caption = #26381#21153#22120#21517#31216#65306
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Microsoft Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label2: TLabel
      Left = 8
      Top = 64
      Width = 48
      Height = 13
      Caption = #29992#25143#21517#65306
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Microsoft Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label3: TLabel
      Left = 8
      Top = 96
      Width = 36
      Height = 13
      Caption = #23494#30721#65306
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Microsoft Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label4: TLabel
      Left = 7
      Top = 126
      Width = 72
      Height = 13
      Caption = #25968#25454#24211#21517#31216#65306
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Microsoft Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object EdtServer: TEdit
      Left = 78
      Top = 28
      Width = 175
      Height = 21
      Enabled = False
      TabOrder = 0
    end
    object EdtUser: TEdit
      Left = 78
      Top = 60
      Width = 175
      Height = 21
      Enabled = False
      TabOrder = 1
    end
    object EdtPwd: TEdit
      Left = 78
      Top = 92
      Width = 175
      Height = 21
      Enabled = False
      TabOrder = 2
    end
    object EdtDbName: TEdit
      Left = 78
      Top = 124
      Width = 175
      Height = 21
      Enabled = False
      TabOrder = 3
    end
    object BtUpdate: TButton
      Left = 152
      Top = 168
      Width = 91
      Height = 25
      Caption = #25968#25454#24211#21319#32423
      Enabled = False
      TabOrder = 4
      OnClick = BtUpdateClick
    end
  end
  object StaticText1: TStaticText
    Left = 0
    Top = 324
    Width = 564
    Height = 17
    Align = alBottom
    BorderStyle = sbsSunken
    Caption = #29366#24577
    TabOrder = 1
  end
  object GroupBox2: TGroupBox
    Left = 257
    Top = 0
    Width = 307
    Height = 324
    Align = alClient
    Caption = #21319#32423#20869#23481
    TabOrder = 2
    object lvmemo: TListView
      Left = 2
      Top = 15
      Width = 303
      Height = 307
      Align = alClient
      Columns = <
        item
          Width = 20
        end
        item
          AutoSize = True
        end>
      ReadOnly = True
      RowSelect = True
      TabOrder = 0
      ViewStyle = vsReport
    end
  end
  object ADOConnection1: TADOConnection
    KeepConnection = False
    LoginPrompt = False
    Provider = 'SQLOLEDB.1'
    Left = 328
    Top = 64
  end
  object ADOComDrop: TADOCommand
    CommandText = 
      'IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_I' +
      'D(N'#39'[dbo].[devcmds]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[dev' +
      'cmds]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects WHERE object_id =' +
      ' OBJECT_ID(N'#39'[dbo].[devcmds_bak]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TAB' +
      'LE [dbo].[devcmds_bak]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects ' +
      'WHERE object_id = OBJECT_ID(N'#39'[dbo].[operatecmds]'#39') AND type in ' +
      '(N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[operatecmds]'#13#10#13#10'IF  EXISTS (SELECT * ' +
      'FROM sys.objects WHERE object_id = OBJECT_ID(N'#39'[dbo].[worktable_' +
      'usrmsg]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[worktable_usrms' +
      'g]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OB' +
      'JECT_ID(N'#39'[dbo].[empitemdefine]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABL' +
      'E [dbo].[empitemdefine]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects' +
      ' WHERE object_id = OBJECT_ID(N'#39'[dbo].[deptadmin]'#39') AND type in (' +
      'N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[deptadmin]'#13#10#13#10'IF  EXISTS (SELECT * FRO' +
      'M sys.objects WHERE object_id = OBJECT_ID(N'#39'[dbo].[dbbackuplog]'#39 +
      ') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[dbbackuplog]'#13#10#13#10'IF  EXI' +
      'STS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#39'[db' +
      'o].[base_personaloption]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo]' +
      '.[base_personaloption]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects ' +
      'WHERE object_id = OBJECT_ID(N'#39'[dbo].[base_operatortemplate]'#39') AN' +
      'D type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[base_operatortemplate]'#13#10#13#10'I' +
      'F  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID' +
      '(N'#39'[dbo].[base_additiondata]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [' +
      'dbo].[base_additiondata]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.object' +
      's WHERE object_id = OBJECT_ID(N'#39'[dbo].[auth_user_user_permission' +
      's]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[auth_user_user_permi' +
      'ssions]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects WHERE object_id' +
      ' = OBJECT_ID(N'#39'[dbo].[auth_user_groups]'#39') AND type in (N'#39'U'#39'))'#13#10'D' +
      'ROP TABLE [dbo].[auth_user_groups]'#13#10#13#10'IF  EXISTS (SELECT * FROM ' +
      'sys.objects WHERE object_id = OBJECT_ID(N'#39'[dbo].[auth_message]'#39')' +
      ' AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[auth_message]'#13#10#13#10'IF  EXI' +
      'STS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#39'[db' +
      'o].[att_attreport]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[att_' +
      'attreport]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects WHERE object' +
      '_id = OBJECT_ID(N'#39'[dbo].[areaadmin]'#39') AND type in (N'#39'U'#39'))'#13#10'DROP ' +
      'TABLE [dbo].[areaadmin]'#13#10#13#10'IF  EXISTS (SELECT * FROM sys.objects' +
      ' WHERE object_id = OBJECT_ID(N'#39'[dbo].[action_log]'#39') AND type in ' +
      '(N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[action_log]'#13#10#13#10'IF  EXISTS (SELECT * F' +
      'ROM sys.objects WHERE object_id = OBJECT_ID(N'#39'[dbo].[auth_user]'#39 +
      ') AND type in (N'#39'U'#39'))'#13#10'DROP TABLE [dbo].[auth_user]'#13#10#13#10'IF  EXIST' +
      'S (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#39'[dbo]' +
      '.[checkinout]'#39') AND type in (N'#39'U'#39'))'#13#10'EXEC sp_rename '#39'checkinout'#39 +
      ', '#39'checkinout_old'#39#13#10#13#10
    Connection = ADOConnection1
    Parameters = <>
    Left = 289
    Top = 64
  end
  object ADOComAtt: TADOCommand
    CommandText = 
      'INSERT INTO checkinout(pin,[checktime],[checktype],[verifycode],' +
      '[SN],[sensorid],[WorkCode],[Reserved],[sn_name])'#13#10#9'select u.badg' +
      'enumber, ck.[checktime],ck.[checktype],ck.[verifycode],ck.[SN],c' +
      'k.[sensorid],ck.[WorkCode],ck.[Reserved],ck.[sn_name] from check' +
      'inout_old ck'#13#10#9#9'left join userinfo u on u.userid = ck.userid'
    Connection = ADOConnection1
    Parameters = <>
    Left = 289
    Top = 104
  end
  object ADOComFinger: TADOCommand
    CommandText = 
      'set identity_insert finger_template ON'#13#10'INSERT INTO finger_templ' +
      'ate(change_time'#13#10'      ,status'#13#10'      ,templateid'#13#10'      ,pin'#13#10' ' +
      '     ,Template'#13#10'      ,FingerID'#13#10'      ,Valid'#13#10'      ,Fpversion'#13 +
      #10'      ,bio_type'#13#10'      ,UTime)   '#13#10'SELECT tp.change_time'#13#10'     ' +
      ' ,tp.status'#13#10'      ,tp.templateid'#13#10'      ,u.badgenumber'#13#10'      ,' +
      'tp.Template'#13#10'      ,tp.FingerID'#13#10'      ,tp.Valid'#13#10'      ,tp.Fpve' +
      'rsion'#13#10'      ,tp.bio_type'#13#10'      ,tp.UTime'#13#10'  FROM  template tp ' +
      'left join userinfo u on u.userid = tp.userid'#13#10'  set identity_ins' +
      'ert finger_template OFF'#13#10
    Connection = ADOConnection1
    Parameters = <>
    Left = 289
    Top = 144
  end
  object ADOComFace: TADOCommand
    CommandText = 
      'set identity_insert face_template ON'#13#10'INSERT INTO face_template(' +
      'change_time'#13#10#9'  ,create_time'#13#10'      ,status'#13#10'      ,templateid'#13#10 +
      '      ,pin'#13#10'      ,facetemp'#13#10'      ,faceid'#13#10'      ,UTime'#13#10'      ' +
      ',valid'#13#10'      ,face_ver)   '#13#10'SELECT tp.change_time'#13#10'      ,tp.cr' +
      'eate_time'#13#10'      ,tp.status'#13#10'      ,tp.templateid'#13#10'      ,u.badg' +
      'enumber'#13#10'      ,tp.facetemp'#13#10'      ,tp.faceid'#13#10'      ,tp.UTime'#13#10 +
      '      ,tp.valid'#13#10'      ,tp.face_ver      '#13#10'  FROM  facetemplate ' +
      'tp left join userinfo u on u.userid = tp.userid'#13#10'  set identity_' +
      'insert face_template OFF'#13#10
    Connection = ADOConnection1
    Parameters = <>
    Left = 289
    Top = 184
  end
  object Timer1: TTimer
    OnTimer = Timer1Timer
    Left = 64
    Top = 24
  end
  object ADOComTemp: TADOCommand
    Connection = ADOConnection1
    Parameters = <>
    Left = 289
    Top = 232
  end
end
